TG: sql_for_qa/70

SQL для тестировщика

Какой из следующих SQL запросов вернет топ-5 наиболее часто встречающихся значений из колонки с названием "cat" таблицы "products"?

Anonymous Quiz

SELECT TOP 5 cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC LIMIT 5;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC FETCH NEXT 5 ROWS ONLY;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC WHERE ROWNUM <= 5;

585 answered

www.tg-me.com/ru/SQL для тестировщика/com.sql_for_qa/70

2.6K viewsMar 26, 2023 at 07:05

tg-me.com/sql_for_qa/70

Create: 2023-03-26
Last Update: 2025-07-02 19:58:03

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/70

SQL для тестировщика Telegram | DID YOU KNOW?

How Does Bitcoin Mining Work?

Bitcoin mining is the process of adding new transactions to the Bitcoin blockchain. It’s a tough job. People who choose to mine Bitcoin use a process called proof of work, deploying computers in a race to solve mathematical puzzles that verify transactions.To entice miners to keep racing to solve the puzzles and support the overall system, the Bitcoin code rewards miners with new Bitcoins. “This is how new coins are created” and new transactions are added to the blockchain, says Okoro.

To pay the bills, Mr. Durov is issuing investors $1 billion to $1.5 billion of company debt, with the promise of discounted equity if the company eventually goes public, the people briefed on the plans said. He has also announced plans to start selling ads in public Telegram channels as soon as later this year, as well as offering other premium services for businesses and users.